﻿CREATE TABLE [dbo].[GDFUNCIONARIOS] (
    [GD_CODIGO_PERSONA]   VARCHAR (20)  NOT NULL,
    [GD_APELLIDOS]        VARCHAR (40)  NOT NULL,
    [GD_NOMBRES]          VARCHAR (40)  NOT NULL,
    [GD_USER_NAME]        VARCHAR (20)  NOT NULL,
    [GD_AREA_ASIGNADA]    VARCHAR (8)   NOT NULL,
    [GD_ESTADO]           VARCHAR (8)   NOT NULL,
    [GD_CARGO]            VARCHAR (40)  NULL,
    [GD_SUPER_USUARIO]    VARCHAR (2)   NOT NULL,
    [GD_SEXO]             VARCHAR (10)  NOT NULL,
    [GD_BANCO]            VARCHAR (40)  NULL,
    [GD_TIPO_CTA]         VARCHAR (40)  NULL,
    [GD_NUM_CTA]          VARCHAR (50)  NULL,
    [GD_DIRECCION]        VARCHAR (120) NULL,
    [GD_TELEFONOS]        VARCHAR (40)  NULL,
    [GD_CELULAR]          VARCHAR (40)  NULL,
    [GD_EMAIL]            VARCHAR (50)  NULL,
    [GD_TITULOS]          VARCHAR (100) NULL,
    [GD_FECHA_NACIMIENTO] DATETIME      NULL,
    [GD_FECHA_INGRESO]    DATETIME      NULL,
    [GD_FECHA_SALIDA]     DATETIME      NULL,
    [GD_OBSERVACION]      VARCHAR (255) NULL,
    [GD_USUARIO]          VARCHAR (20)  NOT NULL,
    [GD_FECHA_REGISTRO]   DATETIME      NOT NULL
);

